Rename Sheet
AutomatR.GoogleSheets.Activities.RenameSheet
The "Rename Sheet" activity in AutomatR is part of the Google Sheets activities package, designed to rename a specified sheet within a Google spreadsheet. This activity simplifies the process of managing sheet names in Google Sheets, enhancing the efficiency of automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| New Sheet Name | Specifies the new name for the sheet. String variables containing the desired new sheet name. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Rename Sheet" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Output | |
| Result | Outputs the result of the "Rename Sheet" operation, indicating whether the sheet renaming was successful or encountered errors. Variables of relevant types (e.g., Boolean variables) to store the operation result. |
How to use:
- Drag and drop the "Rename Sheet" activity onto the workflow.
- Configure the properties by specifying the new sheet name.
- Optionally, configure the delay.
- Place the "Rename Sheet" activity within a "Google Sheets App Scope" to ensure proper authentication and access to the Google Sheets service.
- Execute the workflow to rename the specified sheet in the Google spreadsheet.
Example: Consider an example where the "Rename Sheet" activity is used to rename a sheet named "Sheet1" to "Expenses" within a Google spreadsheet:
Rename Sheet:
New Sheet Name: "Expenses"
Delay: 1
Result: isRenameSuccessful
In this example, the activity renames the sheet from "Sheet1" to "Expenses." The result of the operation (success or failure) is stored in the Boolean variable "isRenameSuccessful" for further handling in the workflow.